{"nbformat": 4, "metadata": {"orig_nbformat": 3}, "cells": [{"cell_type": "code", "execution_count": 11, "outputs": [], "source": "# The usual preamble\n%matplotlib inline\nimport pandas as pd\nimport matplotlib.pyplot as plt\nimport numpy as np\n\n# Make the graphs a bit prettier, and bigger\npd.set_option('display.mpl_style', 'default')\nplt.rcParams['figure.figsize'] = (15, 5)\n\n\n# This is necessary to show lots of columns in pandas 0.12. \n# Not necessary in pandas 0.13.\npd.set_option('display.width', 5000) \npd.set_option('display.max_columns', 60)", "metadata": {"collapsed": false, "trusted": false}}, {"source": "Let's continue with our NYC 311 service requests example.", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 12, "outputs": [], "source": "complaints = pd.read_csv('../data/311-service-requests.csv')", "metadata": {"collapsed": false, "trusted": false}}, {"source": "# 3.1 Selecting only noise complaints", "cell_type": "markdown", "metadata": {}}, {"source": "I'd like to know which borough has the most noise complaints. First, we'll take a look at the data to see what it looks like:", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 13, "outputs": [{"execution_count": 13, "output_type": "execute_result", "data": {"text/plain": "   Unique Key            Created Date             Closed Date Agency                              Agency Name           Complaint Type                    Descriptor        Location Type Incident Zip  Incident Address      Street Name   Cross Street 1                    Cross Street 2 Intersection Street 1 Intersection Street 2 Address Type      City Landmark Facility Type    Status                Due Date Resolution Action Updated Date Community Board    Borough  X Coordinate (State Plane)  Y Coordinate (State Plane) Park Facility Name Park Borough  School Name School Number School Region  School Code School Phone Number School Address  School City School State   School Zip School Not Found  School or Citywide Complaint Vehicle Type Taxi Company Borough Taxi Pick Up Location Bridge Highway Name Bridge Highway Direction Road Ramp Bridge Highway Segment Garage Lot Name Ferry Direction Ferry Terminal Name   Latitude  Longitude                                  Location\n0    26589651  10/31/2013 02:08:41 AM                     NaN   NYPD          New York City Police Department  Noise - Street/Sidewalk                  Loud Talking      Street/Sidewalk        11432  90-03 169 STREET       169 STREET        90 AVENUE                         91 AVENUE                   NaN                   NaN      ADDRESS   JAMAICA      NaN      Precinct  Assigned  10/31/2013 10:08:41 AM         10/31/2013 02:35:17 AM       12 QUEENS     QUEENS                     1042027                      197389        Unspecified       QUEENS  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.708275 -73.791604   (40.70827532593202, -73.79160395779721)\n1    26593698  10/31/2013 02:01:04 AM                     NaN   NYPD          New York City Police Department          Illegal Parking  Commercial Overnight Parking      Street/Sidewalk        11378         58 AVENUE        58 AVENUE         58 PLACE                         59 STREET                   NaN                   NaN    BLOCKFACE   MASPETH      NaN      Precinct      Open  10/31/2013 10:01:04 AM                            NaN       05 QUEENS     QUEENS                     1009349                      201984        Unspecified       QUEENS  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.721041 -73.909453  (40.721040535628305, -73.90945306791765)\n2    26594139  10/31/2013 02:00:24 AM  10/31/2013 02:40:32 AM   NYPD          New York City Police Department       Noise - Commercial              Loud Music/Party  Club/Bar/Restaurant        10032     4060 BROADWAY         BROADWAY  WEST 171 STREET                   WEST 172 STREET                   NaN                   NaN      ADDRESS  NEW YORK      NaN      Precinct    Closed  10/31/2013 10:00:24 AM         10/31/2013 02:39:42 AM    12 MANHATTAN  MANHATTAN                     1001088                      246531        Unspecified    MANHATTAN  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.843330 -73.939144   (40.84332975466513, -73.93914371913482)\n3    26595721  10/31/2013 01:56:23 AM  10/31/2013 02:21:48 AM   NYPD          New York City Police Department          Noise - Vehicle                Car/Truck Horn      Street/Sidewalk        10023    WEST 72 STREET   WEST 72 STREET  COLUMBUS AVENUE                  AMSTERDAM AVENUE                   NaN                   NaN    BLOCKFACE  NEW YORK      NaN      Precinct    Closed  10/31/2013 09:56:23 AM         10/31/2013 02:21:10 AM    07 MANHATTAN  MANHATTAN                      989730                      222727        Unspecified    MANHATTAN  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.778009 -73.980213    (40.7780087446372, -73.98021349023975)\n4    26590930  10/31/2013 01:53:44 AM                     NaN  DOHMH  Department of Health and Mental Hygiene                   Rodent  Condition Attracting Rodents           Vacant Lot        10027   WEST 124 STREET  WEST 124 STREET     LENOX AVENUE  ADAM CLAYTON POWELL JR BOULEVARD                   NaN                   NaN    BLOCKFACE  NEW YORK      NaN           NaN   Pending  11/30/2013 01:53:44 AM         10/31/2013 01:59:54 AM    10 MANHATTAN  MANHATTAN                      998815                      233545        Unspecified    MANHATTAN  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.807691 -73.947387   (40.80769092704951, -73.94738703491433)\n\n[5 rows x 52 columns]", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Unique Key</th>\n      <th>Created Date</th>\n      <th>Closed Date</th>\n      <th>Agency</th>\n      <th>Agency Name</th>\n      <th>Complaint Type</th>\n      <th>Descriptor</th>\n      <th>Location Type</th>\n      <th>Incident Zip</th>\n      <th>Incident Address</th>\n      <th>Street Name</th>\n      <th>Cross Street 1</th>\n      <th>Cross Street 2</th>\n      <th>Intersection Street 1</th>\n      <th>Intersection Street 2</th>\n      <th>Address Type</th>\n      <th>City</th>\n      <th>Landmark</th>\n      <th>Facility Type</th>\n      <th>Status</th>\n      <th>Due Date</th>\n      <th>Resolution Action Updated Date</th>\n      <th>Community Board</th>\n      <th>Borough</th>\n      <th>X Coordinate (State Plane)</th>\n      <th>Y Coordinate (State Plane)</th>\n      <th>Park Facility Name</th>\n      <th>Park Borough</th>\n      <th>School Name</th>\n      <th>School Number</th>\n      <th>School Region</th>\n      <th>School Code</th>\n      <th>School Phone Number</th>\n      <th>School Address</th>\n      <th>School City</th>\n      <th>School State</th>\n      <th>School Zip</th>\n      <th>School Not Found</th>\n      <th>School or Citywide Complaint</th>\n      <th>Vehicle Type</th>\n      <th>Taxi Company Borough</th>\n      <th>Taxi Pick Up Location</th>\n      <th>Bridge Highway Name</th>\n      <th>Bridge Highway Direction</th>\n      <th>Road Ramp</th>\n      <th>Bridge Highway Segment</th>\n      <th>Garage Lot Name</th>\n      <th>Ferry Direction</th>\n      <th>Ferry Terminal Name</th>\n      <th>Latitude</th>\n      <th>Longitude</th>\n      <th>Location</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td> 26589651</td>\n      <td> 10/31/2013 02:08:41 AM</td>\n      <td>                    NaN</td>\n      <td>  NYPD</td>\n      <td>         New York City Police Department</td>\n      <td> Noise - Street/Sidewalk</td>\n      <td>                 Loud Talking</td>\n      <td>     Street/Sidewalk</td>\n      <td> 11432</td>\n      <td> 90-03 169 STREET</td>\n      <td>      169 STREET</td>\n      <td>       90 AVENUE</td>\n      <td>                        91 AVENUE</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td>   ADDRESS</td>\n      <td>  JAMAICA</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td> Assigned</td>\n      <td> 10/31/2013 10:08:41 AM</td>\n      <td> 10/31/2013 02:35:17 AM</td>\n      <td>    12 QUEENS</td>\n      <td>    QUEENS</td>\n      <td> 1042027</td>\n      <td> 197389</td>\n      <td> Unspecified</td>\n      <td>    QUEENS</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.708275</td>\n      <td>-73.791604</td>\n      <td>  (40.70827532593202, -73.79160395779721)</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td> 26593698</td>\n      <td> 10/31/2013 02:01:04 AM</td>\n      <td>                    NaN</td>\n      <td>  NYPD</td>\n      <td>         New York City Police Department</td>\n      <td>         Illegal Parking</td>\n      <td> Commercial Overnight Parking</td>\n      <td>     Street/Sidewalk</td>\n      <td> 11378</td>\n      <td>        58 AVENUE</td>\n      <td>       58 AVENUE</td>\n      <td>        58 PLACE</td>\n      <td>                        59 STREET</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> BLOCKFACE</td>\n      <td>  MASPETH</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td>     Open</td>\n      <td> 10/31/2013 10:01:04 AM</td>\n      <td>                    NaN</td>\n      <td>    05 QUEENS</td>\n      <td>    QUEENS</td>\n      <td> 1009349</td>\n      <td> 201984</td>\n      <td> Unspecified</td>\n      <td>    QUEENS</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.721041</td>\n      <td>-73.909453</td>\n      <td> (40.721040535628305, -73.90945306791765)</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td> 26594139</td>\n      <td> 10/31/2013 02:00:24 AM</td>\n      <td> 10/31/2013 02:40:32 AM</td>\n      <td>  NYPD</td>\n      <td>         New York City Police Department</td>\n      <td>      Noise - Commercial</td>\n      <td>             Loud Music/Party</td>\n      <td> Club/Bar/Restaurant</td>\n      <td> 10032</td>\n      <td>    4060 BROADWAY</td>\n      <td>        BROADWAY</td>\n      <td> WEST 171 STREET</td>\n      <td>                  WEST 172 STREET</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td>   ADDRESS</td>\n      <td> NEW YORK</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td>   Closed</td>\n      <td> 10/31/2013 10:00:24 AM</td>\n      <td> 10/31/2013 02:39:42 AM</td>\n      <td> 12 MANHATTAN</td>\n      <td> MANHATTAN</td>\n      <td> 1001088</td>\n      <td> 246531</td>\n      <td> Unspecified</td>\n      <td> MANHATTAN</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.843330</td>\n      <td>-73.939144</td>\n      <td>  (40.84332975466513, -73.93914371913482)</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td> 26595721</td>\n      <td> 10/31/2013 01:56:23 AM</td>\n      <td> 10/31/2013 02:21:48 AM</td>\n      <td>  NYPD</td>\n      <td>         New York City Police Department</td>\n      <td>         Noise - Vehicle</td>\n      <td>               Car/Truck Horn</td>\n      <td>     Street/Sidewalk</td>\n      <td> 10023</td>\n      <td>   WEST 72 STREET</td>\n      <td>  WEST 72 STREET</td>\n      <td> COLUMBUS AVENUE</td>\n      <td>                 AMSTERDAM AVENUE</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> BLOCKFACE</td>\n      <td> NEW YORK</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td>   Closed</td>\n      <td> 10/31/2013 09:56:23 AM</td>\n      <td> 10/31/2013 02:21:10 AM</td>\n      <td> 07 MANHATTAN</td>\n      <td> MANHATTAN</td>\n      <td>  989730</td>\n      <td> 222727</td>\n      <td> Unspecified</td>\n      <td> MANHATTAN</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.778009</td>\n      <td>-73.980213</td>\n      <td>   (40.7780087446372, -73.98021349023975)</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td> 26590930</td>\n      <td> 10/31/2013 01:53:44 AM</td>\n      <td>                    NaN</td>\n      <td> DOHMH</td>\n      <td> Department of Health and Mental Hygiene</td>\n      <td>                  Rodent</td>\n      <td> Condition Attracting Rodents</td>\n      <td>          Vacant Lot</td>\n      <td> 10027</td>\n      <td>  WEST 124 STREET</td>\n      <td> WEST 124 STREET</td>\n      <td>    LENOX AVENUE</td>\n      <td> ADAM CLAYTON POWELL JR BOULEVARD</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> BLOCKFACE</td>\n      <td> NEW YORK</td>\n      <td> NaN</td>\n      <td>      NaN</td>\n      <td>  Pending</td>\n      <td> 11/30/2013 01:53:44 AM</td>\n      <td> 10/31/2013 01:59:54 AM</td>\n      <td> 10 MANHATTAN</td>\n      <td> MANHATTAN</td>\n      <td>  998815</td>\n      <td> 233545</td>\n      <td> Unspecified</td>\n      <td> MANHATTAN</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.807691</td>\n      <td>-73.947387</td>\n      <td>  (40.80769092704951, -73.94738703491433)</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows \u00d7 52 columns</p>\n</div>"}, "metadata": {}}], "source": "complaints[:5]", "metadata": {"collapsed": false, "trusted": false}}, {"source": "To get the noise complaints, we need to find the rows where the \"Complaint Type\" column is \"Noise - Street/Sidewalk\". I'll show you how to do that, and then explain what's going on.", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 14, "outputs": [{"execution_count": 14, "output_type": "execute_result", "data": {"text/plain": "    Unique Key            Created Date             Closed Date Agency                      Agency Name           Complaint Type        Descriptor    Location Type Incident Zip     Incident Address      Street Name    Cross Street 1 Cross Street 2 Intersection Street 1 Intersection Street 2 Address Type           City Landmark Facility Type    Status                Due Date Resolution Action Updated Date   Community Board        Borough  X Coordinate (State Plane)  Y Coordinate (State Plane) Park Facility Name   Park Borough  School Name School Number School Region  School Code School Phone Number School Address  School City School State   School Zip School Not Found  School or Citywide Complaint Vehicle Type Taxi Company Borough Taxi Pick Up Location Bridge Highway Name Bridge Highway Direction Road Ramp Bridge Highway Segment Garage Lot Name Ferry Direction Ferry Terminal Name   Latitude  Longitude                                 Location\n0     26589651  10/31/2013 02:08:41 AM                     NaN   NYPD  New York City Police Department  Noise - Street/Sidewalk      Loud Talking  Street/Sidewalk        11432     90-03 169 STREET       169 STREET         90 AVENUE      91 AVENUE                   NaN                   NaN      ADDRESS        JAMAICA      NaN      Precinct  Assigned  10/31/2013 10:08:41 AM         10/31/2013 02:35:17 AM         12 QUEENS         QUEENS                     1042027                      197389        Unspecified         QUEENS  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.708275 -73.791604  (40.70827532593202, -73.79160395779721)\n16    26594086  10/31/2013 12:54:03 AM  10/31/2013 02:16:39 AM   NYPD  New York City Police Department  Noise - Street/Sidewalk  Loud Music/Party  Street/Sidewalk        10310  173 CAMPBELL AVENUE  CAMPBELL AVENUE  HENDERSON AVENUE   WINEGAR LANE                   NaN                   NaN      ADDRESS  STATEN ISLAND      NaN      Precinct    Closed  10/31/2013 08:54:03 AM         10/31/2013 02:07:14 AM  01 STATEN ISLAND  STATEN ISLAND                      952013                      171076        Unspecified  STATEN ISLAND  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.636182 -74.116150   (40.63618202176914, -74.1161500428337)\n25    26591573  10/31/2013 12:35:18 AM  10/31/2013 02:41:35 AM   NYPD  New York City Police Department  Noise - Street/Sidewalk      Loud Talking  Street/Sidewalk        10312    24 PRINCETON LANE   PRINCETON LANE     HAMPTON GREEN       DEAD END                   NaN                   NaN      ADDRESS  STATEN ISLAND      NaN      Precinct    Closed  10/31/2013 08:35:18 AM         10/31/2013 01:45:17 AM  03 STATEN ISLAND  STATEN ISLAND                      929577                      140964        Unspecified  STATEN ISLAND  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.553421 -74.196743  (40.55342078716953, -74.19674315017886)\n\n[3 rows x 52 columns]", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Unique Key</th>\n      <th>Created Date</th>\n      <th>Closed Date</th>\n      <th>Agency</th>\n      <th>Agency Name</th>\n      <th>Complaint Type</th>\n      <th>Descriptor</th>\n      <th>Location Type</th>\n      <th>Incident Zip</th>\n      <th>Incident Address</th>\n      <th>Street Name</th>\n      <th>Cross Street 1</th>\n      <th>Cross Street 2</th>\n      <th>Intersection Street 1</th>\n      <th>Intersection Street 2</th>\n      <th>Address Type</th>\n      <th>City</th>\n      <th>Landmark</th>\n      <th>Facility Type</th>\n      <th>Status</th>\n      <th>Due Date</th>\n      <th>Resolution Action Updated Date</th>\n      <th>Community Board</th>\n      <th>Borough</th>\n      <th>X Coordinate (State Plane)</th>\n      <th>Y Coordinate (State Plane)</th>\n      <th>Park Facility Name</th>\n      <th>Park Borough</th>\n      <th>School Name</th>\n      <th>School Number</th>\n      <th>School Region</th>\n      <th>School Code</th>\n      <th>School Phone Number</th>\n      <th>School Address</th>\n      <th>School City</th>\n      <th>School State</th>\n      <th>School Zip</th>\n      <th>School Not Found</th>\n      <th>School or Citywide Complaint</th>\n      <th>Vehicle Type</th>\n      <th>Taxi Company Borough</th>\n      <th>Taxi Pick Up Location</th>\n      <th>Bridge Highway Name</th>\n      <th>Bridge Highway Direction</th>\n      <th>Road Ramp</th>\n      <th>Bridge Highway Segment</th>\n      <th>Garage Lot Name</th>\n      <th>Ferry Direction</th>\n      <th>Ferry Terminal Name</th>\n      <th>Latitude</th>\n      <th>Longitude</th>\n      <th>Location</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0 </th>\n      <td> 26589651</td>\n      <td> 10/31/2013 02:08:41 AM</td>\n      <td>                    NaN</td>\n      <td> NYPD</td>\n      <td> New York City Police Department</td>\n      <td> Noise - Street/Sidewalk</td>\n      <td>     Loud Talking</td>\n      <td> Street/Sidewalk</td>\n      <td> 11432</td>\n      <td>    90-03 169 STREET</td>\n      <td>      169 STREET</td>\n      <td>        90 AVENUE</td>\n      <td>    91 AVENUE</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> ADDRESS</td>\n      <td>       JAMAICA</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td> Assigned</td>\n      <td> 10/31/2013 10:08:41 AM</td>\n      <td> 10/31/2013 02:35:17 AM</td>\n      <td>        12 QUEENS</td>\n      <td>        QUEENS</td>\n      <td> 1042027</td>\n      <td> 197389</td>\n      <td> Unspecified</td>\n      <td>        QUEENS</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.708275</td>\n      <td>-73.791604</td>\n      <td> (40.70827532593202, -73.79160395779721)</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td> 26594086</td>\n      <td> 10/31/2013 12:54:03 AM</td>\n      <td> 10/31/2013 02:16:39 AM</td>\n      <td> NYPD</td>\n      <td> New York City Police Department</td>\n      <td> Noise - Street/Sidewalk</td>\n      <td> Loud Music/Party</td>\n      <td> Street/Sidewalk</td>\n      <td> 10310</td>\n      <td> 173 CAMPBELL AVENUE</td>\n      <td> CAMPBELL AVENUE</td>\n      <td> HENDERSON AVENUE</td>\n      <td> WINEGAR LANE</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> ADDRESS</td>\n      <td> STATEN ISLAND</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td>   Closed</td>\n      <td> 10/31/2013 08:54:03 AM</td>\n      <td> 10/31/2013 02:07:14 AM</td>\n      <td> 01 STATEN ISLAND</td>\n      <td> STATEN ISLAND</td>\n      <td>  952013</td>\n      <td> 171076</td>\n      <td> Unspecified</td>\n      <td> STATEN ISLAND</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.636182</td>\n      <td>-74.116150</td>\n      <td>  (40.63618202176914, -74.1161500428337)</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td> 26591573</td>\n      <td> 10/31/2013 12:35:18 AM</td>\n      <td> 10/31/2013 02:41:35 AM</td>\n      <td> NYPD</td>\n      <td> New York City Police Department</td>\n      <td> Noise - Street/Sidewalk</td>\n      <td>     Loud Talking</td>\n      <td> Street/Sidewalk</td>\n      <td> 10312</td>\n      <td>   24 PRINCETON LANE</td>\n      <td>  PRINCETON LANE</td>\n      <td>    HAMPTON GREEN</td>\n      <td>     DEAD END</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> ADDRESS</td>\n      <td> STATEN ISLAND</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td>   Closed</td>\n      <td> 10/31/2013 08:35:18 AM</td>\n      <td> 10/31/2013 01:45:17 AM</td>\n      <td> 03 STATEN ISLAND</td>\n      <td> STATEN ISLAND</td>\n      <td>  929577</td>\n      <td> 140964</td>\n      <td> Unspecified</td>\n      <td> STATEN ISLAND</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.553421</td>\n      <td>-74.196743</td>\n      <td> (40.55342078716953, -74.19674315017886)</td>\n    </tr>\n  </tbody>\n</table>\n<p>3 rows \u00d7 52 columns</p>\n</div>"}, "metadata": {}}], "source": "noise_complaints = complaints[complaints['Complaint Type'] == \"Noise - Street/Sidewalk\"]\nnoise_complaints[:3]", "metadata": {"collapsed": false, "trusted": false}}, {"source": "If you look at `noise_complaints`, you'll see that this worked, and it only contains complaints with the right complaint type. But how does this work? Let's deconstruct it into two pieces", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 15, "outputs": [{"execution_count": 15, "output_type": "execute_result", "data": {"text/plain": "0      True\n1     False\n2     False\n3     False\n4     False\n5     False\n6     False\n7     False\n8     False\n9     False\n10    False\n11    False\n12    False\n13    False\n14    False\n...\n111054     True\n111055    False\n111056    False\n111057    False\n111058    False\n111059     True\n111060    False\n111061    False\n111062    False\n111063    False\n111064    False\n111065    False\n111066     True\n111067    False\n111068    False\nName: Complaint Type, Length: 111069, dtype: bool"}, "metadata": {}}], "source": "complaints['Complaint Type'] == \"Noise - Street/Sidewalk\"", "metadata": {"collapsed": false, "trusted": false}}, {"source": "This is a big array of `True`s and `False`s, one for each row in our dataframe. When we index our dataframe with this array, we get just the rows where our boolean array evaluated to `True`.  It's important to note that for row filtering by a boolean array the length of our dataframe's index must be the same length as the boolean array used for filtering.\n\nYou can also combine more than one condition with the `&` operator like this:", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 16, "outputs": [{"execution_count": 16, "output_type": "execute_result", "data": {"text/plain": "     Unique Key            Created Date             Closed Date Agency                      Agency Name           Complaint Type        Descriptor    Location Type Incident Zip    Incident Address      Street Name     Cross Street 1  Cross Street 2 Intersection Street 1 Intersection Street 2  Address Type      City Landmark Facility Type  Status                Due Date Resolution Action Updated Date Community Board   Borough  X Coordinate (State Plane)  Y Coordinate (State Plane) Park Facility Name Park Borough  School Name School Number School Region  School Code School Phone Number School Address  School City School State   School Zip School Not Found  School or Citywide Complaint Vehicle Type Taxi Company Borough Taxi Pick Up Location Bridge Highway Name Bridge Highway Direction Road Ramp Bridge Highway Segment Garage Lot Name Ferry Direction Ferry Terminal Name   Latitude  Longitude                                  Location\n31     26595564  10/31/2013 12:30:36 AM                     NaN   NYPD  New York City Police Department  Noise - Street/Sidewalk  Loud Music/Party  Street/Sidewalk        11236            AVENUE J         AVENUE J     EAST 80 STREET  EAST 81 STREET                   NaN                   NaN     BLOCKFACE  BROOKLYN      NaN      Precinct    Open  10/31/2013 08:30:36 AM                            NaN     18 BROOKLYN  BROOKLYN                     1008937                      170310        Unspecified     BROOKLYN  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.634104 -73.911055  (40.634103775951736, -73.91105541883589)\n49     26595553  10/31/2013 12:05:10 AM  10/31/2013 02:43:43 AM   NYPD  New York City Police Department  Noise - Street/Sidewalk      Loud Talking  Street/Sidewalk        11225  25 LEFFERTS AVENUE  LEFFERTS AVENUE  WASHINGTON AVENUE  BEDFORD AVENUE                   NaN                   NaN       ADDRESS  BROOKLYN      NaN      Precinct  Closed  10/31/2013 08:05:10 AM         10/31/2013 01:29:29 AM     09 BROOKLYN  BROOKLYN                      995366                      180388        Unspecified     BROOKLYN  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.661793 -73.959934    (40.6617931276793, -73.95993363978067)\n109    26594653  10/30/2013 11:26:32 PM  10/31/2013 12:18:54 AM   NYPD  New York City Police Department  Noise - Street/Sidewalk  Loud Music/Party  Street/Sidewalk        11222                 NaN              NaN                NaN             NaN         DOBBIN STREET         NORMAN STREET  INTERSECTION  BROOKLYN      NaN      Precinct  Closed  10/31/2013 07:26:32 AM         10/31/2013 12:18:54 AM     01 BROOKLYN  BROOKLYN                      996925                      203271        Unspecified     BROOKLYN  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.724600 -73.954271  (40.724599563793525, -73.95427134534344)\n236    26591992  10/30/2013 10:02:58 PM  10/30/2013 10:23:20 PM   NYPD  New York City Police Department  Noise - Street/Sidewalk      Loud Talking  Street/Sidewalk        11218       DITMAS AVENUE    DITMAS AVENUE                NaN             NaN                   NaN                   NaN       LATLONG  BROOKLYN      NaN      Precinct  Closed  10/31/2013 06:02:58 AM         10/30/2013 10:23:20 PM     01 BROOKLYN  BROOKLYN                      991895                      171051        Unspecified     BROOKLYN  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.636169 -73.972455   (40.63616876563881, -73.97245504682485)\n370    26594167  10/30/2013 08:38:25 PM  10/30/2013 10:26:28 PM   NYPD  New York City Police Department  Noise - Street/Sidewalk  Loud Music/Party  Street/Sidewalk        11218    126 BEVERLY ROAD     BEVERLY ROAD      CHURCH AVENUE   EAST 2 STREET                   NaN                   NaN       ADDRESS  BROOKLYN      NaN      Precinct  Closed  10/31/2013 04:38:25 AM         10/30/2013 10:26:28 PM     12 BROOKLYN  BROOKLYN                      990144                      173511        Unspecified     BROOKLYN  Unspecified   Unspecified   Unspecified  Unspecified         Unspecified    Unspecified  Unspecified  Unspecified  Unspecified                N                           NaN          NaN                  NaN                   NaN                 NaN                      NaN       NaN                    NaN             NaN             NaN                 NaN  40.642922 -73.978762    (40.6429222774404, -73.97876175474585)\n\n[5 rows x 52 columns]", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Unique Key</th>\n      <th>Created Date</th>\n      <th>Closed Date</th>\n      <th>Agency</th>\n      <th>Agency Name</th>\n      <th>Complaint Type</th>\n      <th>Descriptor</th>\n      <th>Location Type</th>\n      <th>Incident Zip</th>\n      <th>Incident Address</th>\n      <th>Street Name</th>\n      <th>Cross Street 1</th>\n      <th>Cross Street 2</th>\n      <th>Intersection Street 1</th>\n      <th>Intersection Street 2</th>\n      <th>Address Type</th>\n      <th>City</th>\n      <th>Landmark</th>\n      <th>Facility Type</th>\n      <th>Status</th>\n      <th>Due Date</th>\n      <th>Resolution Action Updated Date</th>\n      <th>Community Board</th>\n      <th>Borough</th>\n      <th>X Coordinate (State Plane)</th>\n      <th>Y Coordinate (State Plane)</th>\n      <th>Park Facility Name</th>\n      <th>Park Borough</th>\n      <th>School Name</th>\n      <th>School Number</th>\n      <th>School Region</th>\n      <th>School Code</th>\n      <th>School Phone Number</th>\n      <th>School Address</th>\n      <th>School City</th>\n      <th>School State</th>\n      <th>School Zip</th>\n      <th>School Not Found</th>\n      <th>School or Citywide Complaint</th>\n      <th>Vehicle Type</th>\n      <th>Taxi Company Borough</th>\n      <th>Taxi Pick Up Location</th>\n      <th>Bridge Highway Name</th>\n      <th>Bridge Highway Direction</th>\n      <th>Road Ramp</th>\n      <th>Bridge Highway Segment</th>\n      <th>Garage Lot Name</th>\n      <th>Ferry Direction</th>\n      <th>Ferry Terminal Name</th>\n      <th>Latitude</th>\n      <th>Longitude</th>\n      <th>Location</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>31 </th>\n      <td> 26595564</td>\n      <td> 10/31/2013 12:30:36 AM</td>\n      <td>                    NaN</td>\n      <td> NYPD</td>\n      <td> New York City Police Department</td>\n      <td> Noise - Street/Sidewalk</td>\n      <td> Loud Music/Party</td>\n      <td> Street/Sidewalk</td>\n      <td> 11236</td>\n      <td>           AVENUE J</td>\n      <td>        AVENUE J</td>\n      <td>    EAST 80 STREET</td>\n      <td> EAST 81 STREET</td>\n      <td>           NaN</td>\n      <td>           NaN</td>\n      <td>    BLOCKFACE</td>\n      <td> BROOKLYN</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td>   Open</td>\n      <td> 10/31/2013 08:30:36 AM</td>\n      <td>                    NaN</td>\n      <td> 18 BROOKLYN</td>\n      <td> BROOKLYN</td>\n      <td> 1008937</td>\n      <td> 170310</td>\n      <td> Unspecified</td>\n      <td> BROOKLYN</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.634104</td>\n      <td>-73.911055</td>\n      <td> (40.634103775951736, -73.91105541883589)</td>\n    </tr>\n    <tr>\n      <th>49 </th>\n      <td> 26595553</td>\n      <td> 10/31/2013 12:05:10 AM</td>\n      <td> 10/31/2013 02:43:43 AM</td>\n      <td> NYPD</td>\n      <td> New York City Police Department</td>\n      <td> Noise - Street/Sidewalk</td>\n      <td>     Loud Talking</td>\n      <td> Street/Sidewalk</td>\n      <td> 11225</td>\n      <td> 25 LEFFERTS AVENUE</td>\n      <td> LEFFERTS AVENUE</td>\n      <td> WASHINGTON AVENUE</td>\n      <td> BEDFORD AVENUE</td>\n      <td>           NaN</td>\n      <td>           NaN</td>\n      <td>      ADDRESS</td>\n      <td> BROOKLYN</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td> Closed</td>\n      <td> 10/31/2013 08:05:10 AM</td>\n      <td> 10/31/2013 01:29:29 AM</td>\n      <td> 09 BROOKLYN</td>\n      <td> BROOKLYN</td>\n      <td>  995366</td>\n      <td> 180388</td>\n      <td> Unspecified</td>\n      <td> BROOKLYN</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.661793</td>\n      <td>-73.959934</td>\n      <td>   (40.6617931276793, -73.95993363978067)</td>\n    </tr>\n    <tr>\n      <th>109</th>\n      <td> 26594653</td>\n      <td> 10/30/2013 11:26:32 PM</td>\n      <td> 10/31/2013 12:18:54 AM</td>\n      <td> NYPD</td>\n      <td> New York City Police Department</td>\n      <td> Noise - Street/Sidewalk</td>\n      <td> Loud Music/Party</td>\n      <td> Street/Sidewalk</td>\n      <td> 11222</td>\n      <td>                NaN</td>\n      <td>             NaN</td>\n      <td>               NaN</td>\n      <td>            NaN</td>\n      <td> DOBBIN STREET</td>\n      <td> NORMAN STREET</td>\n      <td> INTERSECTION</td>\n      <td> BROOKLYN</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td> Closed</td>\n      <td> 10/31/2013 07:26:32 AM</td>\n      <td> 10/31/2013 12:18:54 AM</td>\n      <td> 01 BROOKLYN</td>\n      <td> BROOKLYN</td>\n      <td>  996925</td>\n      <td> 203271</td>\n      <td> Unspecified</td>\n      <td> BROOKLYN</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.724600</td>\n      <td>-73.954271</td>\n      <td> (40.724599563793525, -73.95427134534344)</td>\n    </tr>\n    <tr>\n      <th>236</th>\n      <td> 26591992</td>\n      <td> 10/30/2013 10:02:58 PM</td>\n      <td> 10/30/2013 10:23:20 PM</td>\n      <td> NYPD</td>\n      <td> New York City Police Department</td>\n      <td> Noise - Street/Sidewalk</td>\n      <td>     Loud Talking</td>\n      <td> Street/Sidewalk</td>\n      <td> 11218</td>\n      <td>      DITMAS AVENUE</td>\n      <td>   DITMAS AVENUE</td>\n      <td>               NaN</td>\n      <td>            NaN</td>\n      <td>           NaN</td>\n      <td>           NaN</td>\n      <td>      LATLONG</td>\n      <td> BROOKLYN</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td> Closed</td>\n      <td> 10/31/2013 06:02:58 AM</td>\n      <td> 10/30/2013 10:23:20 PM</td>\n      <td> 01 BROOKLYN</td>\n      <td> BROOKLYN</td>\n      <td>  991895</td>\n      <td> 171051</td>\n      <td> Unspecified</td>\n      <td> BROOKLYN</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.636169</td>\n      <td>-73.972455</td>\n      <td>  (40.63616876563881, -73.97245504682485)</td>\n    </tr>\n    <tr>\n      <th>370</th>\n      <td> 26594167</td>\n      <td> 10/30/2013 08:38:25 PM</td>\n      <td> 10/30/2013 10:26:28 PM</td>\n      <td> NYPD</td>\n      <td> New York City Police Department</td>\n      <td> Noise - Street/Sidewalk</td>\n      <td> Loud Music/Party</td>\n      <td> Street/Sidewalk</td>\n      <td> 11218</td>\n      <td>   126 BEVERLY ROAD</td>\n      <td>    BEVERLY ROAD</td>\n      <td>     CHURCH AVENUE</td>\n      <td>  EAST 2 STREET</td>\n      <td>           NaN</td>\n      <td>           NaN</td>\n      <td>      ADDRESS</td>\n      <td> BROOKLYN</td>\n      <td> NaN</td>\n      <td> Precinct</td>\n      <td> Closed</td>\n      <td> 10/31/2013 04:38:25 AM</td>\n      <td> 10/30/2013 10:26:28 PM</td>\n      <td> 12 BROOKLYN</td>\n      <td> BROOKLYN</td>\n      <td>  990144</td>\n      <td> 173511</td>\n      <td> Unspecified</td>\n      <td> BROOKLYN</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> Unspecified</td>\n      <td> N</td>\n      <td>NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> NaN</td>\n      <td> 40.642922</td>\n      <td>-73.978762</td>\n      <td>   (40.6429222774404, -73.97876175474585)</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows \u00d7 52 columns</p>\n</div>"}, "metadata": {}}], "source": "is_noise = complaints['Complaint Type'] == \"Noise - Street/Sidewalk\"\nin_brooklyn = complaints['Borough'] == \"BROOKLYN\"\ncomplaints[is_noise & in_brooklyn][:5]", "metadata": {"collapsed": false, "trusted": false}}, {"source": "Or if we just wanted a few columns:", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 17, "outputs": [{"execution_count": 17, "output_type": "execute_result", "data": {"text/plain": "               Complaint Type   Borough            Created Date        Descriptor\n31    Noise - Street/Sidewalk  BROOKLYN  10/31/2013 12:30:36 AM  Loud Music/Party\n49    Noise - Street/Sidewalk  BROOKLYN  10/31/2013 12:05:10 AM      Loud Talking\n109   Noise - Street/Sidewalk  BROOKLYN  10/30/2013 11:26:32 PM  Loud Music/Party\n236   Noise - Street/Sidewalk  BROOKLYN  10/30/2013 10:02:58 PM      Loud Talking\n370   Noise - Street/Sidewalk  BROOKLYN  10/30/2013 08:38:25 PM  Loud Music/Party\n378   Noise - Street/Sidewalk  BROOKLYN  10/30/2013 08:32:13 PM      Loud Talking\n656   Noise - Street/Sidewalk  BROOKLYN  10/30/2013 06:07:39 PM  Loud Music/Party\n1251  Noise - Street/Sidewalk  BROOKLYN  10/30/2013 03:04:51 PM      Loud Talking\n5416  Noise - Street/Sidewalk  BROOKLYN  10/29/2013 10:07:02 PM      Loud Talking\n5584  Noise - Street/Sidewalk  BROOKLYN  10/29/2013 08:15:59 PM  Loud Music/Party\n\n[10 rows x 4 columns]", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Complaint Type</th>\n      <th>Borough</th>\n      <th>Created Date</th>\n      <th>Descriptor</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>31  </th>\n      <td> Noise - Street/Sidewalk</td>\n      <td> BROOKLYN</td>\n      <td> 10/31/2013 12:30:36 AM</td>\n      <td> Loud Music/Party</td>\n    </tr>\n    <tr>\n      <th>49  </th>\n      <td> Noise - Street/Sidewalk</td>\n      <td> BROOKLYN</td>\n      <td> 10/31/2013 12:05:10 AM</td>\n      <td>     Loud Talking</td>\n    </tr>\n    <tr>\n      <th>109 </th>\n      <td> Noise - Street/Sidewalk</td>\n      <td> BROOKLYN</td>\n      <td> 10/30/2013 11:26:32 PM</td>\n      <td> Loud Music/Party</td>\n    </tr>\n    <tr>\n      <th>236 </th>\n      <td> Noise - Street/Sidewalk</td>\n      <td> BROOKLYN</td>\n      <td> 10/30/2013 10:02:58 PM</td>\n      <td>     Loud Talking</td>\n    </tr>\n    <tr>\n      <th>370 </th>\n      <td> Noise - Street/Sidewalk</td>\n      <td> BROOKLYN</td>\n      <td> 10/30/2013 08:38:25 PM</td>\n      <td> Loud Music/Party</td>\n    </tr>\n    <tr>\n      <th>378 </th>\n      <td> Noise - Street/Sidewalk</td>\n      <td> BROOKLYN</td>\n      <td> 10/30/2013 08:32:13 PM</td>\n      <td>     Loud Talking</td>\n    </tr>\n    <tr>\n      <th>656 </th>\n      <td> Noise - Street/Sidewalk</td>\n      <td> BROOKLYN</td>\n      <td> 10/30/2013 06:07:39 PM</td>\n      <td> Loud Music/Party</td>\n    </tr>\n    <tr>\n      <th>1251</th>\n      <td> Noise - Street/Sidewalk</td>\n      <td> BROOKLYN</td>\n      <td> 10/30/2013 03:04:51 PM</td>\n      <td>     Loud Talking</td>\n    </tr>\n    <tr>\n      <th>5416</th>\n      <td> Noise - Street/Sidewalk</td>\n      <td> BROOKLYN</td>\n      <td> 10/29/2013 10:07:02 PM</td>\n      <td>     Loud Talking</td>\n    </tr>\n    <tr>\n      <th>5584</th>\n      <td> Noise - Street/Sidewalk</td>\n      <td> BROOKLYN</td>\n      <td> 10/29/2013 08:15:59 PM</td>\n      <td> Loud Music/Party</td>\n    </tr>\n  </tbody>\n</table>\n<p>10 rows \u00d7 4 columns</p>\n</div>"}, "metadata": {}}], "source": "complaints[is_noise & in_brooklyn][['Complaint Type', 'Borough', 'Created Date', 'Descriptor']][:10]", "metadata": {"collapsed": false, "trusted": false}}, {"source": "# 3.2 A digression about numpy arrays", "cell_type": "markdown", "metadata": {}}, {"source": "On the inside, the type of a column is `pd.Series`", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 18, "outputs": [{"execution_count": 18, "output_type": "execute_result", "data": {"text/plain": "0    1\n1    2\n2    3\ndtype: int64"}, "metadata": {}}], "source": "pd.Series([1,2,3])", "metadata": {"collapsed": false, "trusted": false}}, {"source": "and pandas Series are internally numpy arrays. If you add `.values` to the end of any `Series`, you'll get its internal numpy array", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 19, "outputs": [{"execution_count": 19, "output_type": "execute_result", "data": {"text/plain": "array([1, 2, 3])"}, "metadata": {}}], "source": "np.array([1,2,3])", "metadata": {"collapsed": false, "trusted": false}}, {"cell_type": "code", "execution_count": 20, "outputs": [{"execution_count": 20, "output_type": "execute_result", "data": {"text/plain": "array([1, 2, 3])"}, "metadata": {}}], "source": "pd.Series([1,2,3]).values", "metadata": {"collapsed": false, "trusted": false}}, {"source": "So this binary-array-selection business is actually something that works with any numpy array:", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 21, "outputs": [], "source": "arr = np.array([1,2,3])", "metadata": {"collapsed": false, "trusted": false}}, {"cell_type": "code", "execution_count": 22, "outputs": [{"execution_count": 22, "output_type": "execute_result", "data": {"text/plain": "array([ True, False,  True], dtype=bool)"}, "metadata": {}}], "source": "arr != 2", "metadata": {"collapsed": false, "trusted": false}}, {"cell_type": "code", "execution_count": 23, "outputs": [{"execution_count": 23, "output_type": "execute_result", "data": {"text/plain": "array([1, 3])"}, "metadata": {}}], "source": "arr[arr != 2]", "metadata": {"collapsed": false, "trusted": false}}, {"source": "# 3.3 So, which borough has the most noise complaints?", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 24, "outputs": [{"execution_count": 24, "output_type": "execute_result", "data": {"text/plain": "MANHATTAN        917\nBROOKLYN         456\nBRONX            292\nQUEENS           226\nSTATEN ISLAND     36\nUnspecified        1\ndtype: int64"}, "metadata": {}}], "source": "is_noise = complaints['Complaint Type'] == \"Noise - Street/Sidewalk\"\nnoise_complaints = complaints[is_noise]\nnoise_complaints['Borough'].value_counts()", "metadata": {"collapsed": false, "trusted": false}}, {"source": "It's Manhattan! But what if we wanted to divide by the total number of complaints, to make it make a bit more sense? That would be easy too:", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 25, "outputs": [], "source": "noise_complaint_counts = noise_complaints['Borough'].value_counts()\ncomplaint_counts = complaints['Borough'].value_counts()", "metadata": {"collapsed": false, "trusted": false}}, {"cell_type": "code", "execution_count": 26, "outputs": [{"execution_count": 26, "output_type": "execute_result", "data": {"text/plain": "BRONX            0.014833\nBROOKLYN         0.013864\nMANHATTAN        0.037755\nQUEENS           0.010143\nSTATEN ISLAND    0.007474\nUnspecified      0.000141\ndtype: float64"}, "metadata": {}}], "source": "noise_complaint_counts / complaint_counts", "metadata": {"collapsed": false, "trusted": false}}, {"source": "Oops, why was that zero? That's no good. This is because of integer division in Python 2. Let's fix it, by converting `complaint_counts` into an array of floats.", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 27, "outputs": [{"execution_count": 27, "output_type": "execute_result", "data": {"text/plain": "BRONX            0.014833\nBROOKLYN         0.013864\nMANHATTAN        0.037755\nQUEENS           0.010143\nSTATEN ISLAND    0.007474\nUnspecified      0.000141\ndtype: float64"}, "metadata": {}}], "source": "noise_complaint_counts / complaint_counts.astype(float)", "metadata": {"collapsed": false, "trusted": false}}, {"cell_type": "code", "execution_count": 28, "outputs": [{"execution_count": 28, "output_type": "execute_result", "data": {"text/plain": "<matplotlib.axes.AxesSubplot at 0x113a628d0>"}, "metadata": {}}, {"output_type": "display_data", "metadata": {}, "data": {"image/png": "iVBORw0KGgoAAAANSUhEUgAAA3UAAAF9CAYAAACjwkFkAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3X9w1PWdx/HXLnETlhBTRZNAtV4LRyEZwnCMN2nTgSlz\n4uD0oCPhgFZkAHGOej3Aw6vWGBA4BD1laLh61ZlGqU4xONdyUxA6EWfcIYI0x6ZgZUJp707DgvwK\nG5Zfy3fvD81eQj5JdvPj+91vvs/HjDP7/eaT5b3Dyw955/v5fr6+RCKREAAAAADAlfxOFwAAAAAA\n6D2aOgAAAABwMZo6AAAAAHAxmjoAAAAAcDGaOgAAAABwMZo6AAAAAHCxrJ4GNDY2aseOHZKkOXPm\nqKSkpFdjr1+/rn/8x3/U3/7t3+r+++9P+70BAAAAAJ1129RZlqXa2lpVVlZKktavX6/i4mL5fL60\nx/72t7/VV7/61V69NwAAAADArNvll5FIREVFRQoEAgoEAiooKFAkEkl77NWrV9XY2KjJkyf36r0B\nAAAAAGbdXqlrbW1VMBhUTU2NJCkYDCoajaqoqCitsbt379b999+vCxcu9Oq9AQAAAABm3V6py83N\nVSwW0/z58zVv3jxdunRJeXl5aY2NxWL6+OOPNXHixF6/NwAAAADArNsrdYWFhTp58mTyOBKJqLCw\nMK2xDQ0Nun79ujZv3qzPPvtMN27cUElJiUaOHJnye0vS3r17NWTIkJQ/GAAAAAAMJvn5+fqrv/qr\nTud9iUQi0d03hsPh5A6VFRUVmjBhgiSpvr5e2dnZmjRpUo9j27z33nu6evWqpk+fntL49urq6jr8\nWQAAAADgJQ0NDZo2bVqn8z02dZmCpq7/hEIhlZeXO10GMgy5gAm5gAm5gAm5gAm56F9dNXU8fBwA\nAAAAXIwrdQAAAADgAlypAwAAAIBBiKbOg0KhkNMlIAORC5iQC5iQC5iQC5iQC3vQ1AEAAACAi3FP\nHQAAAAC4APfUAQAAAMAgRFPnQaxthgm5gAm5gAm5gAm5gAm5sAdNHQAAAAC4GPfUAQAAAIALcE8d\nAAAAAAxCNHUexNpmmJALmJALmJALmJALmJALe2Q5XQAADEYnL17V6dZrTpfRZ9bt9yjcHHW6jD67\nMzegorxsp8sAAGBAcE8dAAyAcHNUq3Ydd7oMfOH5GaNVOnK402UAANAn3FMHAAAAAIMQTZ0HsbYZ\nJuQCQKqYL2BCLmBCLuxBUwcAAAAALkZT50Hl5eVOl4AMRC4ApIr5AibkAibkwh40dQAAAADgYjR1\nHsTaZpiQCwCpYr6ACbmACbmwB00dAAAAALgYTZ0HsbYZJuQCQKqYL2BCLmBCLuxBUwcAAAAALkZT\n50GsbYYJuQCQKuYLmJALmJALe9DUAQAAAICL0dR5EGubYUIuAKSK+QIm5AIm5MIeNHUAAAAA4GJZ\nqQxqbGzUjh07JElz5sxRSUlJ2mN/+ctf6tixY/L7/Vq6dKkKCgokSVu3blVzc7MCgYCmTJmiqVOn\n9uXzIAWhUIjfmqATcgEgVcwXMCEXMCEX9uixqbMsS7W1taqsrJQkrV+/XsXFxfL5fGmNnTt3riTp\n448/1q9//WstXbpUkuTz+bRixQqNGDGi3z4UAAAAAHhFj8svI5GIioqKFAgEFAgEVFBQoEgk0uux\nTU1NGjVqVIdziUSiDx8B6eK3JTAhFwBSxXwBE3IBE3Jhjx6v1LW2tioYDKqmpkaSFAwGFY1GVVRU\nlPbYqqoqXbx4Uc8++2zye3JycrRlyxYNGzZMCxcuVGFhYT98LAAAAADwhh6v1OXm5ioWi2n+/Pma\nN2+eLl26pLy8vF6NXbNmjX7wgx+ouro6eW7RokVau3at5s6dq23btnVbS/vnXIRCIY57edz2OlPq\n4Tgzjn/6059mVD1uP25paREyR/u/j0zIh9uPmS84Nh23vc6UejjOjGPmi/497oov0cPaR8uyVFVV\npcrKSiUSCa1bt05r167t9dgzZ87o3//93/XjH/+4w/lPP/1U27dv18qVK43vXVdXp0mTJnVXKlIU\nCnHDKjojF/0r3BzVql3HnS4DX3h+xmiVjhzudBmDBvMFTMgFTMhF/2poaNC0adM6nc/q6Rv9fr9m\nz56dbM4qKiqSX6uvr1d2dnay2epu7EsvvaRoNKqsrCwtWrQoeX7z5s06f/68hg4dqsWLF/fy4yEd\n/I8FE3IBIFXMFzAhFzAhF/bo8UpdpuBKHQA34UpdZuFKHQBgMOjqSh0PH/eg7tbjwrvIBYBUMV/A\nhFzAhFzYg6YOAAAAAFyMps6DWNsME3IBIFXMFzAhFzAhF/agqQMAAAAAF6Op8yDWNsOEXABIFfMF\nTMgFTMiFPWjqAAAAAMDFaOo8iLXNMCEXAFLFfAETcgETcmEPmjoAAAAAcDGaOg9ibTNMyAWAVDFf\nwIRcwIRc2IOmDgAAAABcjKbOg1jbDBNyASBVzBcwIRcwIRf2oKkDAAAAABejqfMg1jbDhFwASBXz\nBUzIBUzIhT1o6gAAAADAxWjqPIi1zTAhFwBSxXwBE3IBE3JhD5o6AAAAAHAxmjoPYm0zTMgFgFQx\nX8CEXMCEXNiDpg4AAAAAXIymzoNY2wwTcgEgVcwXMCEXMCEX9qCpAwAAAAAXo6nzINY2w4RcAEgV\n8wVMyAVMyIU9aOoAAAAAwMVo6jyItc0wIRcAUsV8ARNyARNyYQ+aOgAAAABwMZo6D2JtM0zIBYBU\nMV/AhFzAhFzYg6YOAAAAAFyMps6DWNsME3IBIFXMFzAhFzAhF/bI6mlAY2OjduzYIUmaM2eOSkpK\n0h77y1/+UseOHZPf79fSpUtVUFCQ9nsDAAAAADrr9kqdZVmqra3V008/raefflq1tbVKJBJpj507\nd66qqqpUUVGhX//612m/N/oXa5thQi4ApIr5AibkAibkwh7dNnWRSERFRUUKBAIKBAIqKChQJBLp\n9dimpiaNGjUq7fcGAAAAAJh1u/yytbVVwWBQNTU1kqRgMKhoNKqioqK0x1ZVVenixYt69tln035v\n9C/WNsOEXABIFfMFTMgFTMiFPbq9Upebm6tYLKb58+dr3rx5unTpkvLy8no1ds2aNfrBD36g6urq\ntN+7TfvLt6FQiGOOOeY4Y49bWlqEzNH+7yMT8sExxxxzzDHHvTnuii/RzY1slmWpqqpKlZWVSiQS\nWrdundauXdvrsWfOnNHLL7+sp59+Oq33lqS6ujpNmjSpy68jdaFQiN+aoBNy0b/CzVGt2nXc6TLw\nhednjFbpyOFOlzFoMF/AhFzAhFz0r4aGBk2bNq3T+azuvsnv92v27NnJZquioiL5tfr6emVnZycb\nre7GvvTSS4pGo8rKytLixYt7HA8AAAAASE23V+oyCVfqALgJV+oyC1fqAACDQVdX6nj4OAAAAAC4\nGE2dB3V3kyW8i1wASBXzBUzIBUzIhT1o6gAAAADAxWjqPIgdiGBCLgCkivkCJuQCJuTCHjR1AAAA\nAOBiNHUexNpmmJALAKlivoAJuYAJubAHTR0AAAAAuBhNnQexthkm5AJAqpgvYEIuYEIu7EFTBwAA\nAAAuRlPnQaxthgm5AJAq5guYkAuYkAt70NQBAAAAgIvR1HkQa5thQi4ApIr5AibkAibkwh40dQAA\nAADgYjR1HsTaZpiQCwCpYr6ACbmACbmwB00dAAAAALgYTZ0HsbYZJuQCQKqYL2BCLmBCLuxBUwcA\nAAAALkZT50GsbYYJuQCQKuYLmJALmJALe9DUAQAAAICL0dR5EGubYUIuAKSK+QIm5AIm5MIeNHUA\nAAAA4GI0dR7E2maYkAsAqWK+gAm5gAm5sAdNHQAAAAC4GE2dB7G2GSbkAkCqmC9gQi5gQi7sQVMH\nAAAAAC5GU+dBrG2GCbkAkCrmC5iQC5iQC3vQ1AEAAACAi2WlMqixsVE7duyQJM2ZM0clJSVpj/3Z\nz36mkydPyrIsLVu2TAUFBZKkrVu3qrm5WYFAQFOmTNHUqVP78nmQAtY2w4RcAEgV8wVMyAVMyIU9\nemzqLMtSbW2tKisrJUnr169XcXGxfD5fWmOXLl0qSTpy5Ih27typRx55RJLk8/m0YsUKjRgxot8+\nFAAAAAB4RY/LLyORiIqKihQIBBQIBFRQUKBIJNLrsTk5OcrK6thLJhKJPnwEpIu1zTAhFwBSxXwB\nE3IBE3Jhjx6v1LW2tioYDKqmpkaSFAwGFY1GVVRU1Kux+/bt04wZM5LHOTk52rJli4YNG6aFCxeq\nsLCwjx8JAAAAALyjxyt1ubm5isVimj9/vubNm6dLly4pLy+vV2MPHTqkkSNHatSoUclzixYt0tq1\nazV37lxt27at21rad/qhUIjjXh6Xl5dnVD0cZ8Zxe5lQj9uPW1pahMzR/u8jE/Lh9uP2MqEejjPj\nmJ8vODYdt5cJ9bj9uCu+RA9rHy3LUlVVlSorK5VIJLRu3TqtXbs27bEnTpxQKBTSggULjN/76aef\navv27Vq5cqXx63V1dZo0aVJ3pQJAxgg3R7Vq13Gny8AXnp8xWqUjhztdBgAAfdLQ0KBp06Z1Op/V\n0zf6/X7Nnj072ZxVVFQkv1ZfX6/s7Oxks9Xd2BdffFG333671qxZo7vuukuLFi2SJG3evFnnz5/X\n0KFDtXjx4j58RKQqFAqxExE6IRcAUsV8ARNyARNyYY8emzpJKi0tVWlpaafzZWVlKY+trq42vvfy\n5ctTKQEAAAAAYMDDxz2I35bAhFwASBXzBUzIBUzIhT1o6gAAAADAxWjqPKi7nXPgXeQCQKqYL2BC\nLmBCLuxBUwcAAAAALkZT50GsbYYJuQCQKuYLmJALmJALe9DUAQAAAICL0dR5EGubYUIuAKSK+QIm\n5AIm5MIeNHUAAAAA4GI0dR7E2maYkAsAqWK+gAm5gAm5sAdNHQAAAAC4GE2dB7G2GSbkAkCqmC9g\nQi5gQi7sQVMHAAAAAC5GU+dBrG2GCbkAkCrmC5iQC5iQC3vQ1AEAAACAi9HUeRBrm2FCLgCkivkC\nJuQCJuTCHjR1AAAAAOBiNHUexNpmmJALAKlivoAJuYAJubAHTR0AAAAAuBhNnQexthkm5AJAqpgv\nYEIuYEIu7EFTBwAAAAAuRlPnQaxthgm5AJAq5guYkAuYkAt70NQBAAAAgIvR1HkQa5thQi4ApIr5\nAibkAibkwh40dQAAAADgYjR1HsTaZpiQCwCpYr6ACbmACbmwB00dAAAAALgYTZ0HsbYZJuQCQKqY\nL2BCLmBCLuyR1dOAxsZG7dixQ5I0Z84clZSUpD32Zz/7mU6ePCnLsrRs2TIVFBSk/d4AAAAAgM66\nbeosy1Jtba0qKyslSevXr1dxcbF8Pl9aY5cuXSpJOnLkiHbu3KlHHnkkrfdG/2JtM0zIBYBUMV/A\nhFzAhFzYo9vll5FIREVFRQoEAgoEAiooKFAkEun12JycHGVlZaX93gAAAAAAs26butbWVgWDQdXU\n1KimpkbBYFDRaLTXY/ft26f77rsv7fdG/2JtM0zIBYBUMV/AhFzAhFzYo9umLjc3V7FYTPPnz9e8\nefN06dIl5eXl9WrsoUOHNHLkSI0aNSrt927TPhShUIhjjjnux+Pf//73GVWP249bWlqEzNH+7yMT\n8uH2Y+YLjjnmONVj5ov+Pe6KL5FIJLr6omVZqqqqUmVlpRKJhNatW6e1a9emPfbEiRMKhUJasGBB\nr95bkurq6jRp0qQuvw4AmSTcHNWqXcedLgNfeH7GaJWOHO50GQAA9ElDQ4OmTZvW6XxWd9/k9/s1\ne/bsZLNVUVGR/Fp9fb2ys7OTjVZ3Y1988UXdfvvtWrNmje666y4tWrSo2/EAAAAAgNR0e6Uuk3Cl\nrv+EQiF2IkIn5KJ/caUus3Clrn8xX8CEXMCEXPSvrq7U8fBxAAAAAHAxmjoP4rclMCEXAFLFfAET\ncgETcmEPmjoAAAAAcDGaOg/qbjtUeBe5AJAq5guYkAuYkAt70NQBAAAAgIvR1HkQa5thQi4ApIr5\nAibkAibkwh40dQAAAADgYjR1HsTaZpiQCwCpYr6ACbmACbmwB00dAAAAALgYTZ0HsbYZJuQCQKqY\nL2BCLmBCLuxBUwcAAAAALkZT50GsbYYJuQCQKuYLmJALmJALe9DUAQAAAICL0dR5EGubYUIuAKSK\n+QIm5AIm5MIeNHUAAAAA4GI0dR7E2maYkAsAqWK+gAm5gAm5sAdNHQAAAAC4GE2dB7G2GSbkAkCq\nmC9gQi5gQi7sQVMHAAAAAC5GU+dBrG2GCbkAkCrmC5iQC5iQC3vQ1AEAAACAi9HUeRBrm2FCLgCk\nivkCJuQCJuTCHjR1AAAAAOBiNHUexNpmmJALAKlivoAJuYAJubAHTR0AAAAAuBhNnQexthkm5AJA\nqpgvYEIuYEIu7EFTBwAAAAAulpXKoMbGRu3YsUOSNGfOHJWUlKQ99g9/+INef/11jR8/Xg899FBy\n/NatW9Xc3KxAIKApU6Zo6tSpvf0sSFEoFOK3JuiEXABIFfMFTMgFTMiFPXps6izLUm1trSorKyVJ\n69evV3FxsXw+X0pj25q669ev67vf/a6OHTvW4Xt8Pp9WrFihESNG9PnDAAAAAIDX9Lj8MhKJqKio\nSIFAQIFAQAUFBYpEIimPPXnypCRpwoQJys3NNX5fIpHow0dAuvhtCUzIBYBUMV/AhFzAhFzYo8cr\nda2trQoGg6qpqZEkBYNBRaNRFRUV9Wlsm5ycHG3ZskXDhg3TwoULVVhY2LtPAgAAAAAe1OOVutzc\nXMViMc2fP1/z5s3TpUuXlJeX1+exbRYtWqS1a9dq7ty52rZtW7dj2z/nIhQKcdzL47bXmVIPx5lx\n/NOf/jSj6nH7cUtLi5A52v99ZEI+3H7MfMGx6bjtdabUw3FmHDNf9O9xV3yJHtY+WpalqqoqVVZW\nKpFIaN26dVq7dm2vxh49elQNDQ0dNkpp8+mnn2r79u1auXKl8b3r6uo0adKk7kodcCcvXtXp1muO\n1tAfWlpadOuttzpdRr+4Mzegorxsp8sYFEIhbmTuT+HmqFbtOu50GfjC8zNGq3TkcKfLGDSYL2BC\nLmBCLvpXQ0ODpk2b1ul8Vk/f6Pf7NXv27GRzVlFRkfxafX29srOzk81Wd2N/9atf6fDhw7pw4YIu\nX76spUuXSpI2b96s8+fPa+jQoVq8eHEfPuLAO916bRD9kPaZ0wX0i+dnjKap6ydMuABSxXwBE3IB\nE3Jhjx6bOkkqLS1VaWlpp/NlZWUpj501a5ZmzZrV6fzy5ctTKQEAAAAAYMDDxwFI6n6dNgC0x3wB\nE3IBE3JhD5o6AAAAAHAxmjoAkljzDiB1zBcwIRcwIRf2oKkDAAAAABdLaaMUAF3jUReZh0ddAAOL\nLcphQi5gQi7sQVMH9BGPusg8POoCAAB4CcsvAQBAWvitO0zIBUzIhT1o6gAAAADAxWjqAABAWnju\nFEzIBUzIhT1o6gAAAADAxWjqAABAWrhHBibkAibkwh40dQAAAADgYjR1AAAgLdwjAxNyARNyYQ+a\nOgAAAABwMZo6AACQFu6RgQm5gAm5sAdNHQAAAAC4GE0dAABIC/fIwIRcwIRc2IOmDgAAAABcjKYO\nAACkhXtkYEIuYEIu7EFTBwAAAAAuRlMHAADSwj0yMCEXMCEX9qCpAwAAAAAXo6kDAABp4R4ZmJAL\nmJALe9DUAQAAAICL0dQBAIC0cI8MTMgFTMiFPWjqAAAAAMDFsnoa0NjYqB07dkiS5syZo5KSkrTH\n/uEPf9Drr7+u8ePH66GHHurVewMAgMzAPTIwIRcwIRf26LapsyxLtbW1qqyslCStX79excXF8vl8\nKY1ta9KuX7+u7373uzp27Fiv3hsAAAAAYNbt8stIJKKioiIFAgEFAgEVFBQoEomkPPbkyZOSpAkT\nJig3N7fX7w0AADIH98jAhFzAhFzYo9srda2trQoGg6qpqZEkBYNBRaNRFRUV9Wlsb8YDAAAAADrr\ntqnLzc1VLBbTkiVLlEgk9OqrryovL6/PY3szHgAAtzt58apOt15zuow+G/7VUoWbo06X0Wd35gZU\nlJftdBmDBvdOwYRc2KPbpq6wsDC5hFL6fMlkYWFhr8YmEolev3ebUCiUDEbbpVw7j63b7+m2PjjH\niTy0P0ZmaWlpUehEmPkCSS0tLdLI4ZKcnS9Ot17Tql3H+/8DoleenzFaf2z8UJJz/35wzDHHHKdz\nHAwGZeJL3Nxt3SQcDid3qKyoqNCECRMkSfX19crOztakSZN6HPurX/1Khw8f1oULFzR+/HgtXbq0\n2/EmdXV1Hf4sJ4Sbo/xjnGGenzFapV/8oOYUcpF5yAVulgmZkMhFpsmUXAwW7X/5DrQhF/2roaFB\n06ZN63S+x0calJaWqrS0tNP5srKylMfOmjVLs2bNSnk8AAAAACA1PHwcAAAAfcbVGJiQC3vQ1AEA\nAACAi9HUAQAAoM94HhlMyIU9aOoAAAAAwMVo6gAAANBn3DsFE3JhD5o6AAAAAHAxmjoAAAD0GfdO\nwYRc2IOmDgAAAABcjKYOAAAAfca9UzAhF/agqQMAAAAAF6OpAwAAQJ9x7xRMyIU9aOoAAAAAwMVo\n6gAAANBn3DsFE3JhD5o6AAAAAHCxLKcLAAAA8LKTF6/qdOs1p8vos5aWFt16661Ol9Fnd+YGVJSX\n7XQZg0YoFOJqnQ1o6gAAABx0uvWaVu067nQZ/eQzpwvos+dnjKapg+uw/BIAAADAgOAqnT1o6gAA\nAADAxWjqAAAAAAwInlNnD5o6AAAAAHAxmjoAAAAAA4J76uxBUwcAAAAALkZTBwAAAGBAcE+dPWjq\nAAAAAMDFaOoAAAAADAjuqbMHTR0AAAAAuBhNHQAAAIABwT119shKZVBjY6N27NghSZozZ45KSkrS\nHtvV+a1bt6q5uVmBQEBTpkzR1KlTe/1hAAAAAMBremzqLMtSbW2tKisrJUnr169XcXGxfD5fSmNL\nSkq6PC9JPp9PK1as0IgRI/rtQwEAAABwHvfU2aPH5ZeRSERFRUUKBAIKBAIqKChQJBJJeezJkye7\nPN8mkUj03ycCAAAAAA/p8Upda2urgsGgampqJEnBYFDRaFRFRUUpj217bXqPnJwcbdmyRcOGDdPC\nhQtVWFjYP58MAAAAgKNCoRBX62zQY1OXm5urWCymJUuWKJFI6NVXX1VeXl5aYy3L6vI9Fi1aJEn6\n85//rG3btmnVqlX9+PEAAAAAYHDrcfllYWFhh6WSkUiky6tpXY1N5T1uueUWDRkypNta2u+eEwqF\nbD9uaWnptj44x4k8sJtT5mppaWG+QAft/z6YL9Ce03lgvsg8mTRfDIbj9jKhHrcfd8WXSOGGtnA4\nnNy5sqKiQhMmTJAk1dfXKzs7W5MmTepxbFfnN2/erPPnz2vo0KFavHix7rjjDmMNdXV1Hf4cJ4Sb\no1q167ijNaCj52eMVunI4Y7WQC4yD7nAzTIhExK5yDTkAiaZkgvApKGhQdOmTet0PqVHGpSWlqq0\ntLTT+bKyspTHdnV++fLlqZQAAAAAwGVCIe6pswMPHwcAAAAAF6OpAwAAADAguEpnD5o6AAAAAHAx\nmjoAAAAAA4Ldf+1BUwcAAAAALkZTBwAAAGBAcE+dPWjqAAAAAMDFaOoAAAAADAjuqbMHTR0AAAAA\nuBhNHQAAAIABwT119qCpAwAAAAAXo6kDAAAAMCC4p84eNHUAAAAA4GI0dQAAAAAGBPfU2YOmDgAA\nAABcjKYOAAAAwIDgnjp70NQBAAAAgIvR1AEAAAAYENxTZw+aOgAAAABwMZo6AAAAAAOCe+rsQVMH\nAAAAAC5GUwcAAABgQHBPnT1o6gAAAADAxWjqAAAAAAwI7qmzB00dAAAAALgYTR0AAACAAcE9dfag\nqQMAAAAAF8vqaUBjY6N27NghSZozZ45KSkrSHpvueQAAAADuFwqFuFpng26bOsuyVFtbq8rKSknS\n+vXrVVxcLJ/Pl9LYkpKStM539d4AAAAAALNum7pIJKKioiIFAgFJUkFBQfJcKmNPnjypRCKR8vmu\n3hsAAACA+3CVzh7dNnWtra0KBoOqqamRJAWDQUWjUWPj1dXYttepnqepAwAAAIDUddvU5ebmKhaL\nacmSJUokEnr11VeVl5eX1ljLstI6DwAAAHjdyYtXdbr1mtNl9FlLS4tuvfVWp8vosztzAyrKy3a6\njC5129QVFhbq5MmTyeNIJKLCwsK0xlqWldb5ruTn56uhoaHnTzTAnpvkdAVo70akSQ0Rp6sgF5mG\nXOBmmZIJiVxkEnIBk0zKxWCQK+nG5dNOl9FnJ7/4z2n5+fnG875EIpHo7hvD4XByh8qKigpNmDBB\nklRfX6/s7GxNmjSpx7HpngcAAAAApKbHpg4AAAAAkLl4+DgAAAAAuBhNHQAAAAC4GE0dAAAAALgY\nTd0gd+jQIeP59957z95CkFGuXr3a4b8rV64kX8O7yAWAdDU3N+vIkSNqbm52uhTA07p9pAHc7+jR\no3r//fe1cOFCfelLX1Jzc7Nqamo0evRop0uDg5577rlO506cOKF4PK433njDgYqQCcgFurJnzx5N\nnz5dktTU1KSf//znsixL3//+91VSUuJwdXDCmTNn9JOf/ES33Xab7rjjDp05c0Znz57VP/zDP2jE\niBFOlweHPPnkk5KkK1eu6Nq1a8rLy9P58+c1bNgw/eu//qvD1Q1u7H7pAX/+85/1i1/8Qrfddpta\nW1u1YMGCbp8JCO+wLEv79+/Xvn379LWvfU3333+/brvtNqfLgsPIBW62Zs0aVVVVKZFIaOPGjVqx\nYoUSiYQ2bNigNWvWOF0eHLBp0yZVVFToL/7iL5Ln/vu//1vbt2/XE0884WBlyARbt27VokWLNHTo\nUF28eFG/+MUvtGzZMqfLGtS4UucB0WhU169fV15enj777DO1trY6XRIcduXKFdXV1amhoUH33nuv\nnnjiCWVnZztdFhxGLtCVeDyuWCym/fv3q6ysLJkLv5+7OLzq8uXLHRo6SfrKV76iy5cvO1QRMskn\nn3ySnCfVwDU1AAARAklEQVRyc3P1v//7vw5XNPhxpW6Q27JliwKBgB566CENGzZMFy5c0Ouvv67s\n7Gw9+uijTpcHhyxcuFA+n0/FxcWdfihbuXKlQ1XBaeQCXQmHw3rrrbd0991365FHHpHf75dlWdq2\nbZsefvhhp8uDAxYsWKBRo0Z1Ot/c3KzXXnvNgYqQSf7jP/5Dhw4d0te+9jX96U9/0uTJkzVz5kyn\nyxrUaOoGuaNHj6q4uLjT+cbGRk2YMMGBipAJTp8+LUny+XySpLZpwOfz6Y477nCsLjirfS7aZ0IS\nuQAApOX8+fM6e/as7rzzTuXl5TldzqBHUzfIXblyxfiDuySWVXnYoUOHNHnyZKfLQIazLEtHjx7V\ngQMHtGTJEqfLgYPa74DKvyWQ1O2uuGQC0ufLts+ePauCggKnS/EE7qkb5DZu3NjpHLvZ4b/+67/0\nm9/8RvPmzdNf/uVfOl0OMkg8Hlc4HNaBAwcUDodVWlqq8vJyp8uCw9gZFTfbsGFDsrFvQybQ5oMP\nPtDu3bt16dIlvfDCC9qyZYt++MMfOl3WoMaVOo9gNzvcLBKJqLa2VteuXUsu0fX5fMlty+E9mzdv\n1qlTpzR27FiVlpbq3Xff1eOPP+50Wcgg/FuCm5EJmFRWVmr16tVat26dqqqqkjvoYuBwpW6QYzc7\ndCUej+v69evKzs5WTk6O0+UgA2RlZenGjRuKx+OyLMvpcpBB+LcENyMT6E4ikdD169clSbFYTFxD\nGnhcqRvk2M0OJtXV1YpGo5o3b57uuecep8tBBonH48n76MLhsMaNG6fy8nJNnDjR6dLgIP4twc3I\nBLpz+PBhvfHGGzp37pxGjRql+fPn6+tf/7rTZQ1qNHWD3M27HEr/f5P7nXfe6UhNcN6RI0dUUlLi\ndBnIcJZl6dixYzp48CDb1nucaWfUNvxb4k3sloueWJalaDSqvLy8Tvdfov/R1HlALBbT8ePHFY1G\nNXz4cI0ZM0ZDhw51uiwAGWbv3r267777nC4DgAuxWy7gLH/PQ+Bm+/fv17/8y7/oo48+0oULF/TR\nRx9p3bp12r9/v9OlIQO9+OKLTpcAB9XX1ztdAjLUyy+/nHz95ptvJl9XV1c7UQ4yRDwe1+9+9zv9\n27/9m/7+7/9e77//vu69916nywI8iY1SBrndu3dr9erVysr6/7/qBx98UM8++6y+8Y1vOFgZgExz\n7tw57dmzp9PyOnZFxalTp5Kvm5qakq/Pnj3rRDnIAO13yy0rK9Ply5e1bNkyp8uCw95++209+OCD\nevLJJzt9bcOGDQ5U5B00dYNcIpEw/oDGqltvMz00NpFIsOOhx/n9fnavg5FlWbp69Wpynmj/Gt7E\nbrkweeCBByRJOTk5PMLAZjR1g9yMGTP0zDPPqLS0VMOHD1c0GtXvf/97zZgxw+nS4CDTQ2OB/Px8\nTZ061ekykIF8Pl/yAeR+v7/Da3jTY4891mG33BMnTqi6uprdcj2u7RFJU6ZMcbgS72GjFA+IxWJq\nampSa2urcnNzNWbMGAWDQafLApBh3n33XX372992ugwALsRuuYCz+BWbBwSDQZWWluqb3/ymSktL\nFQwGFQqFnC4LDvrggw86nbtx44a2b9/uQDXIFPF43OkSALiU3+/XuHHjaOgAh9DUDXJ1dXVatWqV\nnnrqKX3yySc6d+6cNm7cqMbGRqdLg4OOHDmivXv3Jo//53/+R88884xuueUWB6uC09j9El1h90uk\nil2UvW3Tpk2SPt9IB/binrpBrq6uThs3btTFixf13HPPKZFI6Hvf+54mTJjgdGlw0JIlS7R9+3a9\n9dZbys7O1sGDB/Xoo4/q7rvvdro0OIjdL9EVdr8EkIqzZ8/q+PHjOnXqlD755JMOD6b/8pe/7HB1\ngxtN3SCXnZ0tv9+v/Px8DRkyRFVVVQoEAk6XhQzwd3/3d3rnnXe0d+9ebdq0qcNjL+BN7H6JrrD7\nJW7GLsowmTdvnvbt26ezZ89q586dHb7GIy8GFj/FDXJ//OMfk88KaW5u7rC9LM8L8a72z485c+aM\n/umf/klDhw6VRC68jN0v0RV2v8TN2jIAtDdx4kRNnDhRLS0tNHE2Y/dLAIAkdr8EAMCtaOo85sKF\nC4rFYho5cqTTpcBhly9fVlNTk6LRqIYPH64xY8Ykr9YB0udL7tqeQbVkyRKnywEAAF2gqRvk3n//\nfe3cuVPBYFAzZ87Url27NGTIEI0fP14zZ850ujw4ZP/+/dq1a5dKSko6PJT+gQce0De+8Q2ny4OD\n4vG4wuGwDhw4oHA4rNLSUpWXl7O5kse1X7LdZsiQIZo1a5YmT57sQEVw2p49e5IbKDU1NennP/+5\nLMvS97//fZWUlDhcHeA93FM3yO3atUsbNmxQLBbT448/rurqagUCAT311FM0dR62e/durV69usPm\nKA8++KCeffZZmjoP27x5s06dOqWxY8eqrKxMly9f5p4ISDLfa3v16lVt2rSJps6jPvjgA02fPl2J\nREJvv/22qqqqlEgktGHDBpo6D3v77bf14IMPGn8RxD37A4umbpDLyclRVlaW8vLyNHLkyOTOdjk5\nOQ5XBiclEgnjtvVcuPe2rKws3bhxQ/F4nB3s0CN2zPW2eDyuWCym/fv3q6ysLPnzBZvneNsDDzwg\n6fOfM9tvzoeBx/LLQW7BggUaNWqUpM93v2y7l665uVmvvfaak6XBQfv379d//ud/qrS0tMPyyxkz\nZuib3/ym0+XBQfF4PHkfXTgc1rhx41ReXq6JEyc6XRoc9KMf/Ug+n6/DOcuy9J3vfEfl5eUOVQUn\nhcNhvfXWW7r77rv1yCOPyO/3y7Isbdu2TQ8//LDT5cFh7733Hrsp24ymDvCoWCym48ePKxqNKjc3\nV2PGjFEwGHS6LGQQy7J07NgxHTx4kB/SkJwzLl68qGHDhmnMmDHKzc3VgQMH9Nd//ddOlwcAnsba\nCcCj2v/W3efzdfotPOD3+zVu3DiNGzfO6VLgsJs3V/rkk09UW1ur8vJyffjhhzR1AOAwrtQBHsTu\nlzBpf2P7hQsXlJ+fnzzmBndvq6ysVFVVVYf76K5fv67ly5fr0UcfZXdUD2q/+2Uq5+Et1dXVeuyx\nx5LHL730klasWOFgRYMfV+oAD2L3S5i0b9zWrFnDTe5I6mpzpS996Us0dB61a9cuSeqUi927d9PU\nQWfOnOlwfOHCBYcq8Q6aOsCD2P0SQDpmzJihZ555xri5ErzJ7/cnd7y8+Tzg9/uTKz7Onj1LLmzA\n8kvAg9j9Eibtl1+23y1XYvklPt8opampSa2trWyuBL3zzju6//77Uz4Pbzl+/LheeeUV5efn6/z5\n81q6dKlGjx7tdFmDGk0d4FH8gAYAAAZKIpFQNBrV8OHD2YzNBjR1AJJCoRDPnPKwq1evdvk10zIr\nAAC6Eo/Hde7cOd15551Ol+IJ3FMHeFBdXZ3eeecd3XLLLVq2bJmCwaBeeeUVDR8+nKbOwzZs2NDp\nt6knTpxQPB7XG2+84VBVAAC3+eCDD7R7925dunRJL7zwgrZs2aIf/vCHTpc1qNHUAR5UV1enjRs3\n6uLFi3ruueeUSCT0ve99j13sPG716tWSPn/o+P79+7Vv3z5Nnz6d+2MAAGn5zW9+o9WrV2vdunWS\npPPnzztc0eBHUwd4UHZ2tvx+v/Lz8zVkyBBVVVUpEAg4XRYcduXKFdXV1amhoUH33nuvnnjiCZZd\nAgDSlkgkdP36dUmf38PP3V4Dj3vqAA9asGCBRo0aJYldDvH/Fi5cKJ/Pp+Li4k7bT69cudKhqgAA\nbnP48GG98cYbOnfunEaNGqX58+fr61//utNlDWo0dQAASdLp06cldXxmYds9dnfccYdjdQEA3Mey\nLEWjUeXl5bH7pQ1YfglAFy5cUCwW63DFDt5z8w5llmXp6NGjOnDggJYsWeJQVQAy0c275SYSieQP\n7izbhiRdvHhRZ86c0ZAhQ5Sbm+t0OYMeTR3gQe+//7527typYDComTNnateuXRoyZIjGjx+vmTNn\nOl0eHBSPxxUOh3XgwAGFw2GVlpayIyqATp577rlO59gtF2127Nihw4cP66tf/ar+9Kc/qaysTDNm\nzHC6rEGNpg7woF27dmnDhg2KxWJ6/PHHVV1drUAgoKeeeoqmzsM2b96sU6dOaezYsSorK9Ply5e1\nbNkyp8sCkIGqqqoksVsuzBoaGrRu3Tr5/X5ZlqUf//jHNHUDjKYO8KCcnBxlZWUpLy9PI0eOTC6V\nycnJcbgyOCkrK0s3btxQPB6XZVlOlwMgg7FbLrpz11136dq1a8rJyVEsFtOXv/xlp0sa9NgoBfCg\nrna/bG5u1muvveZkaXBYPB7X0aNHdfDgQR0+fFjjxo1TeXm5Jk6c6HRpADIIu+WiO8uXL9f169eV\nl5enc+fOadiwYcmmn122BwZNHQBAkvTRRx91OLYsSx9//LE+/PBDbdy40aGqAGQi0265bW7edAnA\nwGP5JQBA0ucbHxQUFKikpKTDb95LSkocrApAJqJxAzKLv+chAAAveOWVVzRr1ixduXJF2dnZeuih\nh5L/AUB7L7/8cvL1m2++mXxdXV3tRDnIMO+++64k6eOPP9Y///M/J48xcGjqAACSpNbWVp09e1aW\nZem2225zuhwAGezUqVPJ101NTcnXZ8+edaIcZJj33ntPkvThhx9q7dq12rNnj7MFeQDLLwEAkqRl\ny5bprrvu0siRI9XY2KjGxsbk19j4AEB7lmXp6tWrSiQSnV4DlmXp0qVLGj58uAKBgILBoNMlDXo0\ndQAASdJPfvITSZ9vfCApuflB2zEAtPH5fMkHkPv9/g6vgW9961t64YUX9Nhjj0mSvvKVrzhc0eDH\n7pcAAAAA4GL8OgUAAABp+e1vf+t0CQDaYfklAAAA0rJ//379zd/8jdNlIEO9+eab+t3vfqdAIJA8\nx0PHBxZNHQAAANJy7tw57dmzp9ODx30+n6ZPn+5QVcgUR48e1fPPP889ljaiqQMAAEBa/H6/srOz\nnS4DGWrs2LG6ePGi8vPznS7FM2jqAAAAkJb8/HxNnTrV6TKQoRobG1VfX9+hqWP55cBi90sAAACk\n5d1339W3v/1tp8sA8AWaOgAAAPSJZVk6evSoDhw4oCVLljhdDuA5LL8EAABA2uLxuMLhsA4cOKBw\nOKzS0lKVl5c7XRYc9OSTT3Y6N2TIEM2aNUuTJ092oCLvoKkDAABAWjZv3qxTp05p7NixKisr0+XL\nl7Vs2TKny4LDTPfNXb16VZs2baKpG2DsMwoAAIC0ZGVl6caNG4rH47Isy+lykMGysriGZAfuqQMA\nAEDa4vF48j66cDiscePGqby8XBMnTnS6NDjEtPzSsix95zvfYWnuAKOpAwAAQJ9YlqVjx47p4MGD\nevjhh50uB/AcmjoAAACkZe/evbrvvvucLgPAF7inDgAAAGmpr693ugQA7XDnIgAAANJy7tw57dmz\nRzcv+PL5fJo+fbpDVQHeRVMHAACAtPj9fmVnZztdBoAv0NQBAAAgLfn5+Zo6darTZQD4AvfUAQAA\nIC3f+ta3nC4BQDvsfgkAAAAALsaVOgAAAKRl7969yddNTU166qmn9KMf/UhHjhxxsCrAu2jqAAAA\nkJa2RxokEgm9/fbbqqqq0urVq1VbW+twZYA3sVEKAAAA0hKPxxWLxbR//36VlZUld8L0+7leADiB\n//MAAACQltmzZ2v9+vX64x//mNw0xbIs3XPPPc4WBngUG6UAAAAAgItxpQ4AAAAAXIymDgAAAABc\njKYOAAAAAFyMpg4AAAAAXIymDgAAAABcjKYOAAAAAFzs/wBAUuXSI0Hg2wAAAABJRU5ErkJggg==\n", "text/plain": "<matplotlib.figure.Figure at 0x113a62e50>"}}], "source": "(noise_complaint_counts / complaint_counts.astype(float)).plot(kind='bar')", "metadata": {"collapsed": false, "trusted": false}}, {"source": "So Manhattan really does complain more about noise than the other boroughs! Neat.", "cell_type": "markdown", "metadata": {}}, {"source": "<style>\n    @font-face {\n        font-family: \"Computer Modern\";\n        src: url('http://mirrors.ctan.org/fonts/cm-unicode/fonts/otf/cmunss.otf');\n    }\n    div.cell{\n        width:800px;\n        margin-left:16% !important;\n        margin-right:auto;\n    }\n    h1 {\n        font-family: Helvetica, serif;\n    }\n    h4{\n        margin-top:12px;\n        margin-bottom: 3px;\n       }\n    div.text_cell_render{\n        font-family: Computer Modern, \"Helvetica Neue\", Arial, Helvetica, Geneva, sans-serif;\n        line-height: 145%;\n        font-size: 130%;\n        width:800px;\n        margin-left:auto;\n        margin-right:auto;\n    }\n    .CodeMirror{\n            font-family: \"Source Code Pro\", source-code-pro,Consolas, monospace;\n    }\n    .text_cell_render h5 {\n        font-weight: 300;\n        font-size: 22pt;\n        color: #4057A1;\n        font-style: italic;\n        margin-bottom: .5em;\n        margin-top: 0.5em;\n        display: block;\n    }\n    \n    .warning{\n        color: rgb( 240, 20, 20 )\n        }  ", "cell_type": "markdown", "metadata": {}}], "nbformat_minor": 0}
